Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM20101
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: RM Open File Group Display Name: Receivables Open Transaction Files
Physical Name: RM20101
Technical Name: RM_OPEN
Group Technical Name: RM_Open_Transaction_Logical_File
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | CUSTNMBR  | Customer Number | String | STR15_RM_Customer_Number | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['RM Open File'].CUSTNMBR AS 'RM Open File-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['RM Open File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
| 2 | CPRCSTNM | Corporate Customer Number | String | STR15_RM_Customer_Number | 15 | |
| 3 | DOCNUMBR | Document Number | String | STR20_Document_Number | 20 | |
| 4 | CHEKNMBR | Check Number | String | STR20_Document_Number | 20 | |
| 5 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
| 6 | BCHSOURC | Batch Source | String | STR15 | 15 | |
| 7 | TRXSORCE | TRX Source | String | STR13 | 13 | |
| 8 | RMDTYPAL | RM Document Type-All | Integer | INT2 | 2 | |
Document Type records the type of document.
Click to show/hide the Document Types
0 Balance Carried Forward
1 Sales / Invoice
2 Scheduled Payments
3 Debit Memo
4 Finance Charge
5 Service Repairs
6 Warranties
7 Credit Memo
8 Returns
9 Payments | ||||||
| 9 | CSHRCTYP | Cash Receipt Type | Integer | GB | 0 | |
| 10 | CBKIDCRD | Checkbook ID Credit Card | String | STR15_Checkbook_ID | 15 | |
| 11 | CBKIDCSH | Checkbook ID Cash | String | STR15_Checkbook_ID | 15 | |
| 12 | CBKIDCHK | Checkbook ID Check | String | STR15_Checkbook_ID | 15 | |
| 13 | DUEDATE | Due Date | Date | DT | 8 | |
| 14 | DOCDATE | Document Date | Date | DT | 8 | |
| 15 | POSTDATE | Post Date | Date | DT_Date | 6 | |
| 16 | PSTUSRID | Post User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['RM Open File'].PSTUSRID AS 'RM Open File-Post User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['RM Open File'].PSTUSRID = ['Users Master'].USERID | ||||||
| 17 | GLPOSTDT | GL Posting Date | Date | DT | 8 | |
| 18 | LSTEDTDT | Last Edit Date | Date | DT_Date | 6 | |
| 19 | LSTUSRED | Last User to Edit | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['RM Open File'].LSTUSRED AS 'RM Open File-Last User to Edit'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['RM Open File'].LSTUSRED = ['Users Master'].USERID | ||||||
| 20 | ORTRXAMT | Original Trx Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 21 | CURTRXAM | Current Trx Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 22 | SLSAMNT | Sales Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 23 | COSTAMNT | Cost Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 24 | FRTAMNT | Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 25 | MISCAMNT | Misc Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 26 | TAXAMNT | Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 27 | COMDLRAM | Commission Dollar Amount | Currency | DLR17_RBSO_STR$ | 17 | |
| 28 | CASHAMNT | Cash Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 29 | DISTKNAM | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 30 | DISAVAMT | Discount Available Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 31 | DISAVTKN | Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 32 | DISCRTND | Discount Returned | Currency | DLR17_RBS0_STR$ | 17 | |
| 33 | DISCDATE | Discount Date | Date | DT | 8 | |
| 34 | DSCDLRAM | Discount Dollar Amount | Currency | DLR11_RBS0_UTR$ | 11 | |
| 35 | DSCPCTAM | Discount Percent Amount | Integer | INT5_%2 | 5 | |
| 36 | WROFAMNT | Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 37 | TRXDSCRN | Transaction Description | String | STR30 | 30 | |
| 38 | CSPORNBR | Customer Purchase Order Number | String | Document_Number | 20 | |
| 39 | SLPRSNID | Salesperson ID | String | STR15_Salesperson_ID | 15 | |
Key to the RM Salesperson Master (RM00301).
Click to show/hideSELECT
['RM Open File'].SLPRSNID AS 'RM Open File-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['RM Open File'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID | ||||||
| 40 | SLSTERCD | Sales Territory Code | String | STR15 | 15 | |
| 41 | DINVPDOF | Date Invoice Paid Off | Date | DT | 8 | |
| 42 | PPSAMDED | PPS Amount Deducted | Currency | DLR17_RBS0_UTR$ | 17 | |
| 43 | GSTDSAMT | GST Discount Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 44 | DELETE1 | Delete | Boolean | YN | 0 | |
| 45 | AGNGBUKT | Aging Bucket | Integer | INT1_U0 | 1 | |
| 46 | VOIDSTTS | Void Status | Integer | INT | 0 | |
| 47 | VOIDDATE | Void Date | Date | DT | 8 | |
| 48 | TAXSCHID | Tax Schedule ID | String | STR15_Tax_Schedule_ID | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['RM Open File'].TAXSCHID AS 'RM Open File-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Open File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 49 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['RM Open File'].CURNCYID AS 'RM Open File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['RM Open File'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
| 50 | PYMTRMID | Payment Terms ID | String | STR20_Payment_Terms_ID | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['RM Open File'].PYMTRMID AS 'RM Open File-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['RM Open File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID | ||||||
| 51 | SHIPMTHD | Shipping Method | String | STR15_Shipping_Method | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['RM Open File'].SHIPMTHD AS 'RM Open File-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['RM Open File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
| 52 | TRDISAMT | Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 53 | SLSCHDID | Sales Schedule ID | String | STR15_LBU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['RM Open File'].SLSCHDID AS 'RM Open File-Sales Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Open File'].SLSCHDID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 54 | FRTSCHID | Freight Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['RM Open File'].FRTSCHID AS 'RM Open File-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Open File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 55 | MSCSCHID | Misc Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['RM Open File'].MSCSCHID AS 'RM Open File-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Open File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 56 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['RM Open File'].NOTEINDX AS 'RM Open File-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RM20101 AS ['RM Open File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['RM Open File'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
| 57 | Tax_Date | Tax Date | Date | DT | 8 | |
| 58 | APLYWITH | Apply Withholding | Boolean | Boolean | 0 | |
| 59 | SALEDATE | Sale Date | Date | DT | 8 | |
| 60 | CORRCTN | Correction | Boolean | CB_Correction | 0 | |
| 61 | SIMPLIFD | Simplified | Boolean | CB_Simplified | 0 | |
| 62 | Electronic | Electronic | Boolean | CB_Electronic | 0 | |
| 63 | ECTRX | EC Transaction | Boolean | CB_EC_Transaction | 0 | |
The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.
Click to show/hide Document Printed flag
0 Not an EU Transaction.
1 EU Transaction. | ||||||
| 64 | BKTSLSAM | Backout Sales Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 65 | BKTFRTAM | Backout Freight Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 66 | BKTMSCAM | Backout Misc Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 67 | BackoutTradeDisc | Backout Trade Discount Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 68 | Factoring | Factoring | Boolean | boolean | 0 | |
| 69 | DIRECTDEBIT | Direct Debit | Boolean | CB_DirectDebit | 0 | |
| 70 | ADRSCODE | Address Code | String | STR15_Address_Code | 15 | |
| 71 | EFTFLAG | EFT Flag | Boolean | CB_EFT | 0 | |
What are the other related table with RM_OPEN. Is there any header and line level tables related?
I’m looking for SQL tables when saving credit memo document.
Thanks
Clicking on the Group Display Name or Group Technical Name at the top of the page will show you the other tables in the group which will include headers, lines, taxes and so on.